Exception: FLEA_Db_Exception_SqlQuery
Message: SQL 错误消息: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'scm LIMIT 1' at line 1"
SQL 语句: "SELECT `my_info`.`id` AS flea_pkref_id, `my_info`.* FROM `my_info` WHERE 2025092901307.scm LIMIT 1"
SQL 错误代码: "7335941".
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Db/Driver/Mysql.php [187]
#9 FLEA_Db_Driver_Mysql::execute('SELECT `my_info`.`id` AS f ...')
ARGS: :
Array
(
[0] => SELECT `my_info`.`id` AS flea_pkref_id, `my_info`.* FROM `my_info` WHERE 2025092901307.scm LIMIT 1
)
SOURCE CODE:
| 177 |
if (!is_null($offset)) {
|
| 178 |
$sql .= " LIMIT " . (int)$offset;
|
| 179 |
if (!is_null($length)) {
|
| 180 |
$sql .= ', ' . (int)$length;
|
| 181 |
} else {
|
| 182 |
$sql .= ', 4294967294';
|
| 183 |
}
|
| 184 |
} elseif (!is_null($length)) {
|
| 185 |
$sql .= " LIMIT " . (int)$length;
|
| 186 |
}
|
| 187 |
return $this->execute($sql);
|
| 188 |
}
|
| 189 |
|
| 190 |
function metaColumns($table)
|
| 191 |
{
|
| 192 |
/**
|
| 193 |
* C CHAR 或 VARCHAR 类型字段
|
| 194 |
* X TEXT 或 CLOB 类型字段
|
| 195 |
* B 二进制数据（BLOB）
|
| 196 |
* N 数值或者浮点数
|
| 197 |
* D 日期
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Db/TableDataGateway.php [446]
#8 FLEA_Db_Driver_Mysql::selectLimit('SELECT `my_info`.`id` AS f ...', 1, )
ARGS: :
Array
(
[0] => SELECT `my_info`.`id` AS flea_pkref_id, `my_info`.* FROM `my_info` WHERE 2025092901307.scm
[1] => 1
[2] =>
)
SOURCE CODE:
| 436 |
$fields = $this->dbo->qfields($fields, $this->fullTableName, $this->schema);
|
| 437 |
if ($enableLinks) {
|
| 438 |
// 当有关联需要处理时，必须获得主表的主键字段值
|
| 439 |
$sql = "SELECT {$distinct} {$this->qpka}, {$fields} FROM {$this->qtableName} {$whereby} {$sortby}";
|
| 440 |
} else {
|
| 441 |
$sql = "SELECT {$distinct} {$fields} FROM {$this->qtableName} {$whereby} {$sortby}";
|
| 442 |
}
|
| 443 |
|
| 444 |
// 根据 $length 和 $offset 参数决定是否使用限定结果集的查询
|
| 445 |
if (null !== $length || null !== $offset) {
|
| 446 |
$result = $this->dbo->selectLimit($sql, $length, $offset);
|
| 447 |
} else {
|
| 448 |
$result = $this->dbo->execute($sql);
|
| 449 |
}
|
| 450 |
|
| 451 |
if ($enableLinks) {
|
| 452 |
/**
|
| 453 |
* 查询时同时将主键值单独提取出来，
|
| 454 |
* 并且准备一个以主键值为键名的二维数组用于关联数据的装配
|
| 455 |
*/
|
| 456 |
$pkvs = array();
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Db/TableDataGateway.php [400]
#7 FLEA_Db_TableDataGateway::findAll('2025092901307.scm', , 1, '*', 1)
ARGS: :
Array
(
[0] => 2025092901307.scm
[1] =>
[2] => 1
[3] => *
[4] => 1
)
SOURCE CODE:
| 390 |
*
|
| 391 |
* @param mixed $conditions
|
| 392 |
* @param string $sort
|
| 393 |
* @param mixed $fields
|
| 394 |
* @param mixed $queryLinks
|
| 395 |
*
|
| 396 |
* @return array
|
| 397 |
*/
|
| 398 |
function & find($conditions, $sort = null, $fields = '*', $queryLinks = true)
|
| 399 |
{
|
| 400 |
$rowset =& $this->findAll($conditions, $sort, 1, $fields, $queryLinks);
|
| 401 |
if (is_array($rowset)) {
|
| 402 |
$row = reset($rowset);
|
| 403 |
} else {
|
| 404 |
$row = false;
|
| 405 |
}
|
| 406 |
unset($rowset);
|
| 407 |
return $row;
|
| 408 |
}
|
| 409 |
|
| 410 |
/**
|
Filename: /webHome/host7642531991/www/app/controller/default.php [16]
#6 FLEA_Db_TableDataGateway::find('2025092901307.scm')
ARGS: :
Array
(
[0] => 2025092901307.scm
)
SOURCE CODE:
| 6 |
function controller_default() {
|
| 7 |
parent::base_mai_controller ();
|
| 8 |
$userarray=array();
|
| 9 |
$cmain = get_model('infoCate');
|
| 10 |
if(isset($_SESSION ['userSession']) )
|
| 11 |
{
|
| 12 |
$this->s_assign('userid',$_SESSION ['userSession']['id']);
|
| 13 |
}
|
| 14 |
if (! empty ( $_REQUEST ['id'] )) {
|
| 15 |
$info = get_model ( 'info' );
|
| 16 |
$ob = $info->find ( $_REQUEST ['id'] );
|
| 17 |
$this->s_assign ( 'ob', $ob);
|
| 18 |
}
|
| 19 |
$this->s_assign ( 'time', date("Y-m-d"));
|
| 20 |
$this->s_assign('qygs' , $cmain->findAll(array('p_id'=>1),'number desc'));
|
| 21 |
$this->s_assign('xwzx' , $cmain->findAll(array('p_id'=>2),'number desc'));
|
| 22 |
$this->s_assign('gcyj' , $cmain->findAll(array('p_id'=>3),'number desc'));
|
| 23 |
$this->s_assign('kjcx' , $cmain->findAll(array('p_id'=>4),'number desc'));
|
| 24 |
$this->s_assign('qywh' , $cmain->findAll(array('p_id'=>5),'number desc'));
|
| 25 |
$this->s_assign('hjyc' , $cmain->findAll(array('p_id'=>6),'number desc'));
|
| 26 |
//logo和底部二维码
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Dispatcher/Simple.php [106]
#5 controller_default::controller_default('default')
ARGS: :
Array
(
[0] => default
)
SOURCE CODE:
| 96 |
|
| 97 |
$controller = null;
|
| 98 |
$controllerClassFilename = null;
|
| 99 |
do {
|
| 100 |
// 载入控制对应的类定义
|
| 101 |
if (!$this->_loadController($controllerClass)) { break; }
|
| 102 |
|
| 103 |
// 构造控制器对象
|
| 104 |
FLEA::setAppInf('FLEA.internal.currentControllerName', $controllerName);
|
| 105 |
FLEA::setAppInf('FLEA.internal.currentActionName', $actionName);
|
| 106 |
$controller = new $controllerClass($controllerName);
|
| 107 |
if (!method_exists($controller, $actionMethod)) { break; }
|
| 108 |
if (method_exists($controller, '__setController')) {
|
| 109 |
$controller->__setController($controllerName, $actionName);
|
| 110 |
}
|
| 111 |
if (method_exists($controller, '__setDispatcher')) {
|
| 112 |
$controller->__setDispatcher($this);
|
| 113 |
}
|
| 114 |
|
| 115 |
// 调用 _beforeExecute() 方法
|
| 116 |
if (method_exists($controller, '_beforeExecute')) {
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Dispatcher/Simple.php [77]
#4 FLEA_Dispatcher_Simple::_executeAction('default', 'index', 'controller_default')
ARGS: :
Array
(
[0] => default
[1] => index
[2] => controller_default
)
SOURCE CODE:
| 67 |
|
| 68 |
/**
|
| 69 |
* 从请求中分析 Controller、Action 和 Package 名字，然后执行指定的 Action 方法
|
| 70 |
*
|
| 71 |
* @return mixed
|
| 72 |
*/
|
| 73 |
function dispatching()
|
| 74 |
{
|
| 75 |
$controllerName = $this->getControllerName();
|
| 76 |
$actionName = $this->getActionName();
|
| 77 |
return $this->_executeAction($controllerName, $actionName, $this->getControllerClass($controllerName));
|
| 78 |
}
|
| 79 |
|
| 80 |
/**
|
| 81 |
* 执行指定的 Action 方法
|
| 82 |
*
|
| 83 |
* @param string $controllerName
|
| 84 |
* @param string $actionName
|
| 85 |
* @param string $controllerClass
|
| 86 |
*
|
| 87 |
* @return mixed
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA.php [815]
#3 FLEA_Dispatcher_Simple::dispatching()
ARGS: :
Array
(
)
SOURCE CODE:
| 805 |
require_once ($MVCPackageFilename);
|
| 806 |
}
|
| 807 |
FLEA::init ();
|
| 808 |
|
| 809 |
// 载入调度器并转发请求到控制器
|
| 810 |
$dispatcherClass = FLEA::getAppInf ( 'dispatcher' );
|
| 811 |
FLEA::loadClass ( $dispatcherClass );
|
| 812 |
|
| 813 |
$dispatcher = & new $dispatcherClass ( $_GET );
|
| 814 |
FLEA::register ( $dispatcher, $dispatcherClass );
|
| 815 |
$dispatcher->dispatching ();
|
| 816 |
}
|
| 817 |
|
| 818 |
/**
|
| 819 |
* 准备运行环境
|
| 820 |
*
|
| 821 |
* @param boolean $loadMVC
|
| 822 |
*/
|
| 823 |
function init($loadMVC = false) {
|
| 824 |
static $firstTime = true;
|
| 825 |
|
Filename: /webHome/host7642531991/www/lib/FLEA/FLEA/Compatibility.php [263]
#2 FLEA::runMVC()
ARGS: :
Array
(
)
SOURCE CODE:
| 253 |
FLEA::init();
|
| 254 |
}
|
| 255 |
|
| 256 |
/**
|
| 257 |
* FLEA 应用程序入口（已经过时，用 FLEA::runMVC() 代替）
|
| 258 |
*
|
| 259 |
* @deprecated
|
| 260 |
*/
|
| 261 |
function run()
|
| 262 |
{
|
| 263 |
FLEA::runMVC();
|
| 264 |
}
|
| 265 |
|
| 266 |
/**
|
| 267 |
* 初始化 Ajax，返回 FLEA_Ajax 对象实例（已经过时，用 FLEA::initAjax() 代替）
|
| 268 |
*
|
| 269 |
* @return FLEA_Ajax
|
| 270 |
* @deprecated
|
| 271 |
*/
|
| 272 |
function & init_ajax()
|
| 273 |
{
|
Filename: /webHome/host7642531991/www/index.php [38]
#1 run()
ARGS: :
Array
(
)
SOURCE CODE:
| 28 |
)
|
| 29 |
)
|
| 30 |
);
|
| 31 |
//FLEA::setAppInf('urlMode', URL_REWRITE);
|
| 32 |
FLEA::setAppInf('controllerAccessor', 'c');
|
| 33 |
FLEA::setAppInf('actionAccessor', 'a');
|
| 34 |
FLEA::setAppInf('logEnabled', false);//ر־¼
|
| 35 |
FLEA::loadAppInf(APP.'config/smarty_config.php');
|
| 36 |
FLEA::import(APP);
|
| 37 |
FLEA::init();
|
| 38 |
run();
|
| 39 |
?> |